SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324811 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324811 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78345,39196,881193,369267,97018,694588,802683,566444,127454,234755,331630,95148,869391,173567,1014706,140362,856343,824640,1015068,531764,393213,320422,261269,111201,968643,845288,724986,397909,955451,716297,979972,467413,300050,780133,48424,575266,198078,1008825,16483,706381,469599,838420,546884,465048,841459,759183,864268,318316,619129,448461,22151,286023,85107,4449,712702,12814,453443,199120,1012518,19593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]