SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594943 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594943 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922253,612260,1021590,296187,533107,54953,252247,248285,456374,738951,274811,982411,2267,328008,762707,912599,782016,1043829,637863,885621,596896,323485,436856,954645,906638,535234,1011731,285527,747086,14557,786972,562736,778441,567253,803280,627337,527573,506185,460095,58512,741434,87241,490360,131427,923670,110430,880692,538432,902772,546118,89943,83293,913066,567920,151798,198619,82328,759783,1030217,927773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]