SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406180 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406180 [ RunTime:0.003959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470438,40924,84152,702990,850571,869339,748660,7413,990716,997196,892335,222991,650858,742284,57538,115837,781869,846464,163935,309895,872273,396257,65210,217828,163701,901377,999324,1027863,125406,64271,290629,440860,456213,610689,752938,455681,853991,729615,945455,125439,627095,708853,1043372,813102,352342,1012662,899965,1006944,152318,931609,887452,43122,49580,98909,994086,19169,724338,377636,239454,350964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001009s ]