SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440501 LIMIT 1 [ RunTime:0.001069s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440501 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77681,100394,548581,748639,1029035,590437,410546,640375,929679,943673,222361,790738,752780,582255,225555,829025,356808,776448,840112,82289,942925,288585,164932,831441,323679,627205,984782,383340,755371,960578,124498,313598,249821,929738,25237,166649,194278,912294,1019034,915396,649138,473699,874339,644426,39904,535777,582746,754365,79038,582311,221545,550539,931939,488347,626499,480960,481525,234023,619754,959889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003399s ]