SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415690 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415690 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535938,366026,462439,245486,898212,1009619,842180,757396,334216,39973,244479,670908,603758,73814,627775,58532,912469,74128,609946,674864,560484,480307,557639,820119,209743,910103,912056,1022133,210642,972996,36780,558137,772666,146708,137490,747224,129770,571984,695746,648302,893042,65420,955063,668122,375287,180402,151620,370469,94023,350760,814056,670425,176948,362750,363920,122592,319901,505253,599485,471105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]