SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042081 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042081 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63512,327812,735478,450532,145536,959201,817229,222065,548396,493518,649796,234567,364555,765831,720775,609674,891177,585057,352462,48877,1021593,611827,868967,927836,96744,821249,404202,104831,625379,99355,227893,742333,772786,203996,1017563,502258,1026057,195447,654783,714787,821976,594939,622387,464472,551514,766826,31667,503779,307024,315678,996240,104061,504893,961856,646048,792174,922958,927801,1021207,235049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]