SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325601 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325601 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620607,73226,412283,6866,364665,926232,224095,578832,694882,1044630,768394,129652,658025,327124,679997,552072,861112,11898,617892,382701,890738,326141,487508,161414,544268,809454,716032,411222,465291,689592,233793,84719,448842,91016,213021,967140,46827,635730,999153,563673,523906,514639,698245,420162,72606,617767,626246,870810,1026204,41947,612290,308870,716456,500017,1032020,55918,89457,905788,897421,199519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]