SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412691 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412691 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910889,910148,386835,673269,451554,220501,114210,754196,266658,498840,122448,725453,758083,321543,789682,777098,440269,559649,204125,1005493,244420,348280,281789,180330,982379,781872,731782,607573,720658,614461,970817,172422,1007053,791745,593021,413328,714150,575347,162697,674941,648439,710605,765307,1017532,60771,823612,362463,202568,912875,555374,213489,394809,444358,137638,73630,637175,634434,705060,248391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]