SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106041 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106041 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314767,795649,896329,912449,736246,352547,985258,472874,238203,35815,1001953,921619,368799,469656,694154,1001285,327120,250070,155222,764756,669705,98349,296013,211561,278292,122704,321587,599535,205658,17242,737667,143818,1034688,602540,573580,1007145,35505,858553,29868,438956,476186,26334,217331,448965,685268,777198,386599,250848,229010,553815,113713,927412,51925,66051,797592,408743,535810,289384,712489,831204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]