SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 864628 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 864628 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104344,1015330,418284,964406,752673,987294,164796,27799,495978,918142,119746,1044971,18333,91751,1047194,935467,163097,342072,609850,941367,352886,352334,111366,1034351,939370,882964,412470,60979,359664,1025948,589433,994548,64221,494678,921209,544210,354653,398979,744121,464394,750216,590332,561947,812584,660159,523072,712297,633751,164767,535674,475163,296878,254627,370498,51730,1021299,854551,678908,692227,376920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 864628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 864628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001613s ]