SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019670 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019670 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911309,28239,155544,618109,576530,607844,846364,571978,810137,180990,353682,337634,333219,840846,126319,58149,649353,1044379,935435,209344,6709,202871,498551,140757,625999,609364,499269,886358,982310,263884,474085,1013178,725226,240438,256147,16844,613035,598361,200263,87665,40611,798149,864501,324752,493229,713870,512864,1016268,743687,1030508,539152,257699,622762,253849,214146,210552,1020533,700869,1023168,412428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]