SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314881 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314881 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481888,676444,920738,751764,133938,545959,887905,461075,170221,894984,501103,140799,20438,460895,31816,91693,853102,416561,396441,475311,906230,636228,778267,367938,476870,334070,270540,361978,567166,14102,820700,362309,142840,839285,104655,507341,863591,314003,148404,167551,589,1048024,594790,1004690,441398,523994,649953,735601,116112,7537,424882,640123,418689,528010,226122,552395,510773,44780,606290,766138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002745s ]