SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101284 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101284 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487380,16600,433525,314198,400773,178744,511898,683957,771658,858878,784234,521751,223648,439077,65380,545127,456220,972402,89095,536166,603747,596996,947355,36239,951996,950785,1002735,130114,1046112,960633,371689,619659,708370,696345,488984,670598,271997,717391,92159,928960,226545,279284,314231,308146,902202,283421,760145,957752,101911,401654,397565,525772,733505,178437,1004802,579069,981932,404815,93968,531934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]