SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329453 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329453 [ RunTime:0.004273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603677,610631,1000414,1021317,234728,127140,862105,333066,911910,141419,271093,14072,89880,878956,253321,364407,38928,1019116,507347,467500,342951,441231,43096,554120,890530,302649,829785,119468,155882,994884,1013919,90815,337171,142312,589096,50407,174214,336738,962659,620443,320137,190342,89730,405419,367756,569354,281284,355466,128739,363979,463213,669296,68044,131089,106140,959508,553884,850688,342625,38931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]