SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579913 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579913 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345703,521187,301226,23494,415654,989592,814615,872327,269260,743439,488283,806498,650336,806120,602262,317706,1040769,232109,675430,359453,137641,811728,1022069,735337,568320,637713,301375,208333,643847,596757,493079,940946,223817,623330,788460,11923,867081,645968,368600,909647,880893,1000919,228533,723926,757578,459818,1020476,804920,308890,189708,730878,1028543,743682,828206,252337,522846,949676,300309,836107,760314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]