SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260728 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260728 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48238,123640,216520,41129,255842,423495,1036661,489494,708139,802165,854544,458423,446882,278052,640795,369512,7660,626987,326674,481850,661162,744927,1019956,677580,606750,507806,595730,965800,111074,757220,1026133,544196,683829,801115,585564,704278,59988,310786,933227,384989,272502,724454,809593,349210,566592,697154,310871,743010,364129,306659,269945,288475,427217,530493,284300,210367,797820,501679,865793,681689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]