SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102043 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102043 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643988,202696,809429,101681,669815,776624,880563,309447,915625,711938,908908,468186,797219,732162,350778,755340,419444,626963,555398,455519,150976,948187,5359,571159,392404,636430,411505,144277,529414,403561,147217,160134,291957,445956,807763,649841,570040,914059,945298,891440,244848,1001197,887530,317618,867755,131665,324437,846101,426712,174962,409337,637868,778618,705211,446924,535776,212032,1006719,237850,521185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001707s ]