SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536621 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536621 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399452,335507,1007094,931410,802339,1023683,900145,169415,662169,737106,205206,859978,474001,914501,945115,37237,58952,517670,311423,831412,1022041,715775,18311,404835,805848,964024,818951,225948,505354,167005,1017892,784077,275768,849850,183972,784128,1024184,687375,998018,739031,118695,136609,243260,358595,116109,145269,200353,1028282,101165,1034546,401277,747750,117699,848257,954064,703020,36925,580465,20030,183670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]