SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585328 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585328 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315231,721464,701649,656396,181069,102990,184069,171845,70369,898074,989181,55364,389013,827187,70872,53263,524285,123970,520739,650657,478616,305559,787513,626979,347553,681601,1011028,395203,951323,104804,260900,156370,743481,1047670,24705,526633,627905,183761,627176,14672,1032984,727121,864332,350760,239957,549799,211321,763396,400538,1004921,223598,113065,845414,681289,517898,879207,550255,81723,919833,298825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]