SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129811 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129811 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536308,39667,144073,1015266,582560,939617,779443,963766,443246,186711,806441,296305,365138,381009,136465,295385,641499,114818,676036,307499,326075,262025,65399,170740,493450,444253,260509,1041125,1002709,756003,617880,496425,135177,627367,897094,337517,1011450,987100,915444,679661,492530,731096,605079,867582,63049,609112,674555,1042888,258478,377368,1047755,709265,806560,284672,611765,325779,364440,819087,767160,1018416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]