SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585460 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585460 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550526,482514,787688,106336,718545,358328,452008,930429,859355,950185,206478,450901,195643,19620,69495,632459,627566,946800,524731,107406,320277,230945,843783,113789,109967,835999,217141,262820,199097,501938,197526,638870,658976,609843,390045,926889,132561,669500,282394,839659,957228,753521,150546,795995,816174,112175,538255,1033263,85414,290098,296732,788119,754191,757775,913123,62631,1008342,763263,295475,452769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001652s ]