SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501270 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501270 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836852,587249,935362,123379,308381,907393,734832,812551,567689,644807,237488,721972,189855,662378,700985,329866,320447,969113,886185,722439,561403,831582,997542,220515,25317,587671,975073,597080,678812,661881,624804,553594,801729,698489,21056,695569,423158,18817,365221,899512,670672,393646,263117,113839,660510,198147,45063,82268,996186,794312,803218,980757,875710,571087,182243,988441,348449,959208,588231,898505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]