SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918944 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918944 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545085,286994,391265,38568,482522,401413,260914,764669,787224,476917,631095,547881,323404,397573,701759,721011,211957,476268,1021590,985722,380511,734517,769397,462056,544072,878930,344695,374525,271167,1010284,1006316,929070,172276,398236,112026,280924,375272,35023,845702,1019650,362929,192859,41111,655784,173311,385880,455352,998198,968275,170963,721687,784295,1003222,640136,416158,1036311,94887,506666,854934,222187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]