SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485006 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485006 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260292,673697,920129,1017347,174282,130382,251043,937930,93225,7378,214558,878770,1034460,361444,305877,685361,909520,915761,573783,427357,607663,336756,161934,147628,263396,960230,911961,83713,375559,949839,604733,7122,887898,636099,1047455,567996,622161,112938,13203,995607,283796,402295,579380,1038627,564691,289844,20366,1033799,700609,1026515,1030245,439593,284402,93867,512930,102112,601744,996970,306441,658541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]