SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401841 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401841 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541653,819516,421103,154725,479154,455114,395089,691225,544234,727239,181605,202378,937115,473956,893267,160654,961004,984588,731608,659245,57684,93670,659192,418720,5465,857189,556429,46527,535436,915388,501267,666990,443315,411835,776403,618437,198845,37391,429601,212024,720386,747740,362004,875227,902165,280705,641957,1035486,1009868,648088,685692,761611,1038680,970435,903224,610752,607961,155657,942774,396648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001600s ]