SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33623 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33623 [ RunTime:0.005704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120634,259139,700104,942486,177598,936656,1022222,354668,9048,772973,1017110,242399,793088,841824,802321,679744,635392,870010,866553,85859,310223,322296,618873,923200,233847,884100,92476,443409,519239,1033394,79829,464348,728595,196404,45178,836928,260772,11335,549178,858616,167448,264027,178836,483460,492304,500790,800576,176993,964727,312796,608474,919139,212490,855370,339335,75903,168804,223097,881933,720299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]