SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343203 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343203 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251167,249648,92260,894568,519070,579965,900741,447251,940641,865270,506976,958173,64625,820837,229054,125383,322140,445821,973286,646368,1007634,707969,214150,731924,703675,311635,458531,748180,164233,469641,69854,91995,150012,9358,147670,289404,189693,217277,948041,498058,540827,760821,295208,982327,35640,364445,70129,527529,699334,1027990,4120,373056,6930,221029,327633,735456,415515,240938,364161,524338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]