SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543215 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543215 [ RunTime:0.003036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373852,13737,318264,136422,650439,40217,180416,296835,259217,757080,622206,598031,1018312,268114,1035343,182497,24435,387469,131527,874969,6842,239218,229885,8015,689816,64885,1036820,450949,292668,295013,246510,78121,984005,223636,820656,875308,172447,60079,227091,1045734,531622,812912,187855,148260,975725,986042,268890,236182,444322,647686,440199,686346,289471,545104,32816,875298,51356,161429,621074,951451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003795s ]