SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423791 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423791 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487911,424725,306133,546964,831000,68273,941380,25658,247251,997959,1034927,538999,867926,75701,810342,827381,245591,19026,524388,14081,998305,405508,522427,346747,143983,516478,912909,152562,478863,633061,439715,1032466,619630,395460,33005,74827,811128,684784,791691,779233,604942,494636,290106,115058,492589,5268,157100,283765,231213,69870,792124,586603,1021670,728151,1047552,306716,201512,447382,279893,100011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]