SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417864 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417864 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300603,819212,20943,449159,84243,880790,419444,374341,951088,362809,193755,67328,567278,604012,846758,909341,142599,83185,123211,436450,709759,313092,808461,806257,333030,369963,30282,37842,465719,928535,478346,911561,94136,1026239,666877,749030,577054,564771,827571,804447,194739,694298,523969,725742,989935,847608,637068,859307,234611,931343,17628,865013,697717,534187,12531,735780,461257,436725,484045,257682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]