SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40642 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40642 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241122,70924,655786,421416,296152,295538,882785,577532,552670,361531,200515,881618,401493,280579,152525,261579,832857,733488,914400,803156,175014,377739,1013482,13415,1003650,870157,723128,235365,847385,680510,703192,48181,258188,1011291,179279,105423,744771,1039662,863525,287555,97293,827982,934394,214662,881454,912461,235406,266534,265092,1005648,174523,376823,229352,963825,225060,332333,437277,144229,101226,423859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]