SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417544 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417544 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393286,848185,539206,431957,937181,892639,871071,788434,933401,934548,410074,913730,98040,746664,286572,290686,212588,221626,798563,708943,1048584,392747,500018,421928,459168,404898,539962,879338,843341,351672,122432,341040,813942,357146,548311,168560,140774,475617,873414,309734,298624,982337,150495,287520,553569,80848,717440,268190,378089,48834,799946,578648,37064,659189,317133,825119,870164,696939,867030,901705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]