SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546191 LIMIT 1 [ RunTime:0.001852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546191 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193462,461355,892091,48269,180710,272234,180581,286172,291837,537123,1027965,351750,274541,430180,646666,408329,465036,768983,565492,581941,232795,325010,109020,304017,402670,311500,309138,714330,56653,767819,1035650,475152,215061,158785,467039,152411,701660,706875,234848,415594,1048799,22462,1017621,347044,56889,1027767,28259,241278,579915,746058,47966,1008102,896785,995054,952684,251666,820281,320530,975419,689161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]