SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568823 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568823 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922083,335187,656546,652305,834666,527426,781450,1045934,65100,133161,296056,956306,987269,836563,120396,611339,367854,758866,739536,763136,324352,310092,204582,352266,711272,819872,472009,684423,206868,337551,147813,152798,705218,927650,955668,774237,350564,451747,1033358,256551,503895,194262,468112,30453,984350,985988,2162,807527,847685,955670,974725,443986,330045,731562,820999,929732,768469,73722,46707,868622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005087s ]