SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042494 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042494 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010803,462208,308520,850631,858792,538264,403669,102405,709910,215453,972943,408400,736220,108021,443653,427697,104196,134079,416617,467112,1043471,718994,156907,400064,431399,405674,1009758,58494,69935,646512,678256,75456,24294,796288,124435,587845,987192,398490,522027,851629,855677,1022630,424913,49249,353214,109382,849328,1036241,202703,207269,33685,637563,971482,119447,1010687,264674,910303,868268,657296,23369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]