SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425203 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425203 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924947,361555,1019018,906832,69025,454365,980002,382472,72309,136015,666102,837076,625131,880291,732785,818351,699533,249217,335998,585123,872931,447922,816135,861465,166336,688137,948202,490506,394148,174460,173300,899827,487558,318364,474078,1017250,716738,211517,816281,224861,880861,127642,718029,359168,138511,201230,46424,53394,82185,782287,630928,457670,706393,496725,276598,457739,315908,999221,789469,978441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]