SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475551 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475551 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875493,140948,243200,466644,199664,546994,704257,888667,255942,86360,420285,211671,182068,754608,564527,683902,543204,358889,315566,292861,588855,100829,645737,574504,383805,435586,834455,600501,348337,665444,191983,654431,454621,97255,885557,603605,1045218,836138,596647,17740,393563,1007536,615532,619314,364326,638880,363385,940034,434372,685352,931339,910640,907949,134946,657833,389247,453568,777852,96743,482526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]