SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704208 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704208 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047722,970342,847582,981520,436669,849347,467800,445941,200849,780101,1174,790789,255313,222302,89903,137997,985150,604655,405051,940943,409619,445956,843637,220866,711234,419358,1036749,775854,295014,539428,213383,975917,1044052,452324,277244,262013,485226,491852,960170,568502,824281,99448,729515,717215,560381,513940,1011076,43090,801090,139831,17438,448223,86496,694347,250753,627932,924600,557863,110796,738031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]