SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563760 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563760 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578320,829191,144102,950504,420942,637138,531670,978876,472965,398227,354402,389566,480345,254389,794674,814694,382990,579187,446960,158868,611240,77968,325099,812675,723722,270054,766623,1040476,456455,631635,243015,717995,808476,41722,39873,1032298,294034,4162,520763,102952,792155,572916,6751,636220,279420,765796,62560,1039239,269636,761137,250996,1043641,771414,1002078,686879,194106,580470,672497,17074,115964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000832s ]