SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506501 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506501 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184843,226200,996377,742367,110585,985349,584015,564883,372180,1021508,293107,793045,688383,33962,947709,589959,45572,860647,578036,738798,515631,473155,986757,388499,1002400,1019164,606928,91733,208323,293640,758972,69544,127132,978864,327529,983070,397389,837643,659515,483905,980461,21248,186141,967957,139654,209174,340880,973297,355614,40886,257778,702572,262956,434778,300751,903886,135700,26833,1018694,303884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]