SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472311 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472311 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396793,866025,660870,9697,578915,835662,111304,451232,463015,949557,885114,444427,772804,539080,88736,89154,1012054,377304,542252,55378,290608,777625,894024,679898,900006,494810,577232,516760,497649,919249,406540,235892,1044104,394806,502131,173536,656326,327684,579537,758523,366859,320737,26115,58193,1007361,824140,440070,632323,765801,981556,171957,469359,297351,387621,907980,1018574,280016,890394,13852,552313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]