SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504678 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504678 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505870,899434,367820,685201,447255,1024279,840802,666347,568252,257294,879072,947776,630942,254476,188011,339423,492728,270888,600220,361754,272123,339160,688783,74754,249528,442402,411132,725804,1767,504104,91092,311098,54424,460032,343054,656452,639581,42294,1021703,87452,994470,735211,308469,765701,187716,247809,259221,852324,273559,488772,13866,878347,235649,590861,513147,258262,515465,174609,334968,366004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002119s ]