SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446031 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446031 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66382,535748,62547,984825,677740,632680,1046263,222491,172811,950568,347432,125796,890062,884090,869180,107440,297061,848868,575140,435223,840760,1020346,659132,810146,125561,959960,876145,492151,642007,91020,527661,237083,628138,668781,178891,838979,954741,742267,963966,182879,440507,139199,322158,695202,977700,976372,408339,996035,126415,2594,989556,98955,697871,363722,802446,629256,812439,267706,16275,81416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]