SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50177 LIMIT 1 [ RunTime:0.000601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50177 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36187,720394,815277,441762,62311,717722,735852,234847,175447,1045212,100909,76493,1017019,399936,462077,335301,962817,1036107,51256,86847,478036,96518,448123,1779,148085,973786,311732,692989,997799,412670,994196,208265,574527,1032700,906293,949011,308675,431188,663748,81005,1041344,914851,605966,1024457,704687,1001680,448078,698859,723018,336235,10879,809346,190083,213339,1041695,692969,121335,479402,843791,641544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]