SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991380 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991380 [ RunTime:0.001393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519315,266963,594425,579349,804092,112453,1034657,948057,824054,872520,431420,51176,1042880,753010,739728,593753,92616,338888,629075,885533,236695,642664,379647,134308,606295,806322,75584,904679,960898,467747,635795,416562,93205,419023,358310,302626,722845,273807,692124,1009697,798142,977764,845210,42675,150748,599406,32800,135050,353613,1031884,511942,840555,994147,144207,420536,983617,595040,198363,291229,810356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]