SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340943 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340943 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378188,289945,142985,867380,849499,237659,24672,367965,516924,378639,283408,404360,394304,381079,876525,342869,112138,887356,723857,60361,981937,914076,334294,756295,110367,652119,11759,136599,531553,883273,836787,176069,61519,288590,1009328,1042123,633988,778730,346372,796793,562398,895015,83682,436089,170638,113296,339923,539975,652471,332781,581788,266613,905169,36844,75055,874928,999436,119793,533885,125846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]