SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805097 LIMIT 1 [ RunTime:0.000818s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805097 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047700,420129,52875,243898,762000,822258,440854,634552,92459,250870,77961,1047275,541493,932106,397141,256502,924914,428106,839535,676519,428283,460171,136242,303695,257300,369308,43469,852169,61486,48479,380471,526971,363022,846694,358501,770679,115547,824286,923176,770965,683556,554023,571179,887342,346845,894684,479609,429658,23388,372914,248589,121205,611747,535973,364279,840468,617729,42694,458907,552742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]