SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044901 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044901 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784975,854333,644945,295913,75786,333068,615039,296106,196179,115823,112233,788619,464904,714000,270095,932428,32206,102976,451173,794305,32775,844692,134741,562287,802373,51332,8775,650527,260751,826162,282368,680883,460716,403544,862884,351319,685134,303468,119568,542445,581465,750626,879174,125108,986193,288831,952506,672541,1046760,1009321,757641,284248,489143,83899,649438,731077,205178,1037817,691697,83840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]