SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020887 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020887 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344591,100260,927212,558481,386090,858863,642965,163252,255845,563042,149921,494046,1019531,735763,446054,555083,405594,74246,1001291,426422,661556,1018395,985128,301291,732173,135014,570642,738602,992926,612568,777307,533347,699137,889605,403019,260800,67020,482421,1034368,823268,94326,1008345,1007908,151268,861265,325741,444068,471314,115277,375900,515915,680893,484919,977959,823794,490360,535272,187372,625996,531069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]