SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380111 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380111 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195465,684187,481859,188324,482171,487962,111445,142474,554416,1029414,953162,134227,766849,258318,2269,880168,906240,325983,963112,645213,220769,854813,97494,484407,321747,144622,1009112,469330,717686,292708,969824,753935,825635,917488,518019,219102,211221,867100,475214,226454,177641,589393,400162,620050,690320,872914,46462,737832,784390,274989,251959,87393,1039913,212372,706568,66253,187935,10449,564903,312134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000923s ]