SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344713 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344713 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892920,235632,493913,988223,453310,204906,676569,438306,8382,599966,328412,167742,868035,225657,645630,497623,989428,786139,892987,626453,267746,376997,33496,331144,604047,786263,578438,274440,493267,247798,837575,493243,378419,1029126,867674,108075,824616,24542,74145,769912,164302,48019,909627,531413,822980,886024,254839,529435,147477,463824,16309,941731,234901,222695,205694,586560,721573,963576,385058,352372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]