SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299198 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299198 [ RunTime:0.004500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684001,818035,1004894,22810,495282,1002444,1014380,297972,434802,598692,410290,48565,835255,930593,731796,775883,412469,49056,284842,962643,955866,875618,655037,829685,531518,220108,307295,257755,167266,36381,145326,441325,335043,216361,879773,613516,192726,142005,525312,913314,784753,460139,706455,60436,340334,893351,36718,91585,13426,323168,682952,362677,963826,431971,439223,488272,189301,450832,904113,948151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]