SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109569 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109569 [ RunTime:0.003790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878991,22567,226811,89282,335175,591962,236509,326471,139706,89733,1027514,539355,340969,373757,674280,649156,939687,1038042,192006,1013192,1044210,117838,252104,446365,260896,725461,68200,991895,11006,711827,1035884,834126,980869,919505,880148,130524,729694,791982,950687,130292,382842,98467,816808,146473,557545,297764,303460,269178,139982,236287,183553,20422,344888,145175,234405,590827,705592,215645,64321,835610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]