SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173180 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173180 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151638,412446,76867,320408,735428,944899,292380,109155,561745,29457,698647,804666,762150,736220,814354,130661,338149,984206,476103,331453,217877,260738,1005073,1032429,380179,343753,490830,750064,935819,237679,421159,935837,774913,26591,45386,519048,723344,774688,976759,577983,416280,101713,1020312,990294,818324,674218,794153,440298,72795,431447,800447,427615,268822,317417,183090,582945,717922,350061,808957,758884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]