SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454303 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454303 [ RunTime:0.006844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234348,567771,295697,769588,335938,401469,1019591,736645,932790,706815,6062,1003387,26945,77178,290894,59881,101161,680065,974313,74272,577220,269652,269323,628603,101171,1025888,698423,331925,565872,723356,374167,937415,1024808,762126,510321,744485,420128,284558,941272,597614,40310,435282,789912,628792,894317,62362,264108,739486,573677,391034,971347,720634,830677,522573,310495,383268,548607,140848,531200,208496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]