SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36863 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36863 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575463,814290,565413,281478,373732,187189,821751,1034286,693528,673399,558999,715051,47886,642083,469043,878754,953888,520060,869662,322692,658841,221649,532547,439374,234179,640805,414733,998764,182796,825981,919001,744943,360889,62985,813415,939914,176054,430553,907824,902177,926193,286786,625190,425493,324029,696368,257516,188791,848954,218228,220381,1007010,983146,756396,460955,839059,813983,96358,185797,182941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]