SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585441 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585441 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319816,820379,728777,295927,983650,468297,802035,503903,628605,209819,1003550,860423,191254,885036,50685,330817,146541,922831,503729,357982,1002528,428040,790983,593210,373246,210929,17713,221367,509811,249082,558368,250858,818132,484723,925911,530967,345969,508975,601220,505391,513001,901333,153394,22699,865825,71751,180317,353355,946608,128062,590141,329245,525864,825359,707578,734530,90009,334788,245357,390178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]