SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921998 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921998 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508868,1001851,921215,908148,299706,1008794,229437,891994,1023868,100105,351954,785369,340291,71964,414723,467027,225552,617125,517450,462362,384106,404662,693186,967792,104089,323419,62689,676070,675475,218513,988022,764738,334825,492269,749224,75914,468006,610898,427275,504392,452310,11250,662722,524187,737544,919571,423846,439457,256492,871094,161404,759239,265037,96590,86177,854177,546582,292715,618210,177520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001830s ]