SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453433 LIMIT 1 [ RunTime:0.002504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453433 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607275,110861,546476,709662,592439,697119,736729,975340,203580,823756,442532,1013712,355131,787478,212747,660107,313001,495989,52241,941481,803115,34173,1029329,966237,1015756,101272,886116,795221,17926,97444,352850,119163,542975,346222,583013,625436,256657,110516,997284,648754,90627,711071,847034,501135,577046,363156,613511,581883,577039,510049,965891,470682,76631,485428,86879,63037,951938,517105,404354,816277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]