SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154028 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154028 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325525,320306,26292,416115,647103,341841,1010860,128358,1008109,296375,572409,159783,698163,424088,237719,402866,14680,5047,341338,1024625,698962,608185,692705,63310,545587,878767,95798,921871,305457,966329,115008,519181,648191,596963,278910,409632,646786,418548,802522,635550,898741,761572,797955,947443,940141,16261,914809,704259,54671,781214,629010,572643,269605,950104,613595,1042983,499801,1003289,556703,274487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002958s ]