SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34762 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34762 [ RunTime:0.002366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910792,255769,1020487,423955,22201,783363,197294,391530,285780,565895,962357,40385,505800,87205,937020,303423,239627,683075,34732,1011973,672875,688299,680790,319136,61388,480647,615893,494087,415608,50001,991222,585979,764749,106515,546429,301007,689231,855302,794809,561269,462984,897878,158244,70773,298240,641470,735042,75814,1017888,728918,285116,744064,491083,590246,975172,749857,821792,777564,430690,99543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]