SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483822 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483822 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307242,756774,588615,482976,27911,251500,61968,276990,849134,12462,746537,726343,239336,177254,613828,742420,371988,963953,131710,78122,992197,539469,357835,851481,225718,237806,1040840,32776,1012023,162447,323566,872380,674747,1048676,308019,692656,245945,483387,762982,762628,826169,923685,797514,144284,175143,1040120,185601,783920,441240,718607,593272,629191,782579,917649,1005200,684355,610162,782640,552501,518411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]