SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481199 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481199 [ RunTime:0.004863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798691,144788,304811,531112,727447,85874,774005,785476,690450,503178,1041362,286230,159209,586793,232200,906154,780667,997877,444780,542373,174383,1007808,806997,1040978,1015113,206868,115114,818241,806489,214953,874440,749689,141779,1043579,482637,886755,361663,288475,442692,534322,108943,167034,230863,261078,211300,1001396,938332,900660,358783,801243,567507,1018819,256204,355533,329893,88520,27767,158848,248287,1011478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]