SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980211 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980211 [ RunTime:0.002388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902397,311115,828079,574368,558420,789026,93762,564386,638276,436873,908060,639650,326548,165592,82239,401207,807592,847611,822624,304520,182086,662798,919297,734907,378,259577,742020,83989,101406,109980,777143,810573,67531,913254,240277,531672,738789,476720,875039,1026546,835380,902326,1003140,941499,727556,861217,732856,164883,195054,554991,277352,484851,322882,81771,201766,1017821,625570,3253,295274,273178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]